Re: Question on locking - Mailing list pgsql-novice

From M. Bastin
Subject Re: Question on locking
Date
Msg-id a06110407bdb12b9f480e@[192.168.0.116]
Whole thread Raw
In response to Re: Question on locking  ("M. Bastin" <marcbastin@mindspring.com>)
List pgsql-novice
Note: after thinking a little about it there's no need to use SELECT
FOR UPDATE with Tom's method.  A regular UPDATE will do (it does its
own locking all by itself for only the time needed).

(Therefore, if Tom's method would be the only recommendable one, the
command SELECT FOR UPDATE would be without purpose.  From this again
I deduce that it originally must have been meant for use in long
lasting transactions.)

pgsql-novice by date:

Previous
From: "M. Bastin"
Date:
Subject: Re: Question on locking
Next
From: "M. Bastin"
Date:
Subject: Re: Question on locking